﻿if exists (select * from dbo.sysobjects where name = 'sp_tblAdmin_Update')
	drop procedure [dbo].[sp_tblAdmin_Update]
Go 
CREATE PROCEDURE dbo.sp_tblAdmin_Update
@_aid	int,
@_aname	nvarchar(256),
@_apassword	nvarchar(256),
@_arole	smallint
AS
UPDATE tblAdmin SET [_aname] = @_aname,[_apassword] = @_apassword,[_arole] = @_arole
WHERE  _aid= @_aid
Go